package com.base.po.voip;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class UsersExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public UsersExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andUsernameIsNull() {
            addCriterion("UserName is null");
            return (Criteria) this;
        }

        public Criteria andUsernameIsNotNull() {
            addCriterion("UserName is not null");
            return (Criteria) this;
        }

        public Criteria andUsernameEqualTo(String value) {
            addCriterion("UserName =", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotEqualTo(String value) {
            addCriterion("UserName <>", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameGreaterThan(String value) {
            addCriterion("UserName >", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameGreaterThanOrEqualTo(String value) {
            addCriterion("UserName >=", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameLessThan(String value) {
            addCriterion("UserName <", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameLessThanOrEqualTo(String value) {
            addCriterion("UserName <=", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameLike(String value) {
            addCriterion("UserName like", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotLike(String value) {
            addCriterion("UserName not like", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameIn(List<String> values) {
            addCriterion("UserName in", values, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotIn(List<String> values) {
            addCriterion("UserName not in", values, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameBetween(String value1, String value2) {
            addCriterion("UserName between", value1, value2, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotBetween(String value1, String value2) {
            addCriterion("UserName not between", value1, value2, "username");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNull() {
            addCriterion("Password is null");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNotNull() {
            addCriterion("Password is not null");
            return (Criteria) this;
        }

        public Criteria andPasswordEqualTo(String value) {
            addCriterion("Password =", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotEqualTo(String value) {
            addCriterion("Password <>", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThan(String value) {
            addCriterion("Password >", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("Password >=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThan(String value) {
            addCriterion("Password <", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThanOrEqualTo(String value) {
            addCriterion("Password <=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLike(String value) {
            addCriterion("Password like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotLike(String value) {
            addCriterion("Password not like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordIn(List<String> values) {
            addCriterion("Password in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotIn(List<String> values) {
            addCriterion("Password not in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordBetween(String value1, String value2) {
            addCriterion("Password between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotBetween(String value1, String value2) {
            addCriterion("Password not between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("Email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("Email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("Email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("Email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("Email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("Email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("Email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("Email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("Email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("Email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("Email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("Email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("Email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("Email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterionForJDBCDate("CreateTime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("CreateTime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterionForJDBCDate("CreateTime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CreateTime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterionForJDBCDate("CreateTime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CreateTime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterionForJDBCDate("CreateTime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("CreateTime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CreateTime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CreateTime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andLogintimeIsNull() {
            addCriterion("LoginTime is null");
            return (Criteria) this;
        }

        public Criteria andLogintimeIsNotNull() {
            addCriterion("LoginTime is not null");
            return (Criteria) this;
        }

        public Criteria andLogintimeEqualTo(Date value) {
            addCriterion("LoginTime =", value, "logintime");
            return (Criteria) this;
        }

        public Criteria andLogintimeNotEqualTo(Date value) {
            addCriterion("LoginTime <>", value, "logintime");
            return (Criteria) this;
        }

        public Criteria andLogintimeGreaterThan(Date value) {
            addCriterion("LoginTime >", value, "logintime");
            return (Criteria) this;
        }

        public Criteria andLogintimeGreaterThanOrEqualTo(Date value) {
            addCriterion("LoginTime >=", value, "logintime");
            return (Criteria) this;
        }

        public Criteria andLogintimeLessThan(Date value) {
            addCriterion("LoginTime <", value, "logintime");
            return (Criteria) this;
        }

        public Criteria andLogintimeLessThanOrEqualTo(Date value) {
            addCriterion("LoginTime <=", value, "logintime");
            return (Criteria) this;
        }

        public Criteria andLogintimeIn(List<Date> values) {
            addCriterion("LoginTime in", values, "logintime");
            return (Criteria) this;
        }

        public Criteria andLogintimeNotIn(List<Date> values) {
            addCriterion("LoginTime not in", values, "logintime");
            return (Criteria) this;
        }

        public Criteria andLogintimeBetween(Date value1, Date value2) {
            addCriterion("LoginTime between", value1, value2, "logintime");
            return (Criteria) this;
        }

        public Criteria andLogintimeNotBetween(Date value1, Date value2) {
            addCriterion("LoginTime not between", value1, value2, "logintime");
            return (Criteria) this;
        }

        public Criteria andLoginipIsNull() {
            addCriterion("LoginIp is null");
            return (Criteria) this;
        }

        public Criteria andLoginipIsNotNull() {
            addCriterion("LoginIp is not null");
            return (Criteria) this;
        }

        public Criteria andLoginipEqualTo(String value) {
            addCriterion("LoginIp =", value, "loginip");
            return (Criteria) this;
        }

        public Criteria andLoginipNotEqualTo(String value) {
            addCriterion("LoginIp <>", value, "loginip");
            return (Criteria) this;
        }

        public Criteria andLoginipGreaterThan(String value) {
            addCriterion("LoginIp >", value, "loginip");
            return (Criteria) this;
        }

        public Criteria andLoginipGreaterThanOrEqualTo(String value) {
            addCriterion("LoginIp >=", value, "loginip");
            return (Criteria) this;
        }

        public Criteria andLoginipLessThan(String value) {
            addCriterion("LoginIp <", value, "loginip");
            return (Criteria) this;
        }

        public Criteria andLoginipLessThanOrEqualTo(String value) {
            addCriterion("LoginIp <=", value, "loginip");
            return (Criteria) this;
        }

        public Criteria andLoginipLike(String value) {
            addCriterion("LoginIp like", value, "loginip");
            return (Criteria) this;
        }

        public Criteria andLoginipNotLike(String value) {
            addCriterion("LoginIp not like", value, "loginip");
            return (Criteria) this;
        }

        public Criteria andLoginipIn(List<String> values) {
            addCriterion("LoginIp in", values, "loginip");
            return (Criteria) this;
        }

        public Criteria andLoginipNotIn(List<String> values) {
            addCriterion("LoginIp not in", values, "loginip");
            return (Criteria) this;
        }

        public Criteria andLoginipBetween(String value1, String value2) {
            addCriterion("LoginIp between", value1, value2, "loginip");
            return (Criteria) this;
        }

        public Criteria andLoginipNotBetween(String value1, String value2) {
            addCriterion("LoginIp not between", value1, value2, "loginip");
            return (Criteria) this;
        }

        public Criteria andRoleIsNull() {
            addCriterion("Role is null");
            return (Criteria) this;
        }

        public Criteria andRoleIsNotNull() {
            addCriterion("Role is not null");
            return (Criteria) this;
        }

        public Criteria andRoleEqualTo(Integer value) {
            addCriterion("Role =", value, "role");
            return (Criteria) this;
        }

        public Criteria andRoleNotEqualTo(Integer value) {
            addCriterion("Role <>", value, "role");
            return (Criteria) this;
        }

        public Criteria andRoleGreaterThan(Integer value) {
            addCriterion("Role >", value, "role");
            return (Criteria) this;
        }

        public Criteria andRoleGreaterThanOrEqualTo(Integer value) {
            addCriterion("Role >=", value, "role");
            return (Criteria) this;
        }

        public Criteria andRoleLessThan(Integer value) {
            addCriterion("Role <", value, "role");
            return (Criteria) this;
        }

        public Criteria andRoleLessThanOrEqualTo(Integer value) {
            addCriterion("Role <=", value, "role");
            return (Criteria) this;
        }

        public Criteria andRoleIn(List<Integer> values) {
            addCriterion("Role in", values, "role");
            return (Criteria) this;
        }

        public Criteria andRoleNotIn(List<Integer> values) {
            addCriterion("Role not in", values, "role");
            return (Criteria) this;
        }

        public Criteria andRoleBetween(Integer value1, Integer value2) {
            addCriterion("Role between", value1, value2, "role");
            return (Criteria) this;
        }

        public Criteria andRoleNotBetween(Integer value1, Integer value2) {
            addCriterion("Role not between", value1, value2, "role");
            return (Criteria) this;
        }

        public Criteria andDatastatusIsNull() {
            addCriterion("DataStatus is null");
            return (Criteria) this;
        }

        public Criteria andDatastatusIsNotNull() {
            addCriterion("DataStatus is not null");
            return (Criteria) this;
        }

        public Criteria andDatastatusEqualTo(Boolean value) {
            addCriterion("DataStatus =", value, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusNotEqualTo(Boolean value) {
            addCriterion("DataStatus <>", value, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusGreaterThan(Boolean value) {
            addCriterion("DataStatus >", value, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusGreaterThanOrEqualTo(Boolean value) {
            addCriterion("DataStatus >=", value, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusLessThan(Boolean value) {
            addCriterion("DataStatus <", value, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusLessThanOrEqualTo(Boolean value) {
            addCriterion("DataStatus <=", value, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusIn(List<Boolean> values) {
            addCriterion("DataStatus in", values, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusNotIn(List<Boolean> values) {
            addCriterion("DataStatus not in", values, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusBetween(Boolean value1, Boolean value2) {
            addCriterion("DataStatus between", value1, value2, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusNotBetween(Boolean value1, Boolean value2) {
            addCriterion("DataStatus not between", value1, value2, "datastatus");
            return (Criteria) this;
        }

        public Criteria andMobileIsNull() {
            addCriterion("Mobile is null");
            return (Criteria) this;
        }

        public Criteria andMobileIsNotNull() {
            addCriterion("Mobile is not null");
            return (Criteria) this;
        }

        public Criteria andMobileEqualTo(String value) {
            addCriterion("Mobile =", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotEqualTo(String value) {
            addCriterion("Mobile <>", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThan(String value) {
            addCriterion("Mobile >", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThanOrEqualTo(String value) {
            addCriterion("Mobile >=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThan(String value) {
            addCriterion("Mobile <", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThanOrEqualTo(String value) {
            addCriterion("Mobile <=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLike(String value) {
            addCriterion("Mobile like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotLike(String value) {
            addCriterion("Mobile not like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileIn(List<String> values) {
            addCriterion("Mobile in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotIn(List<String> values) {
            addCriterion("Mobile not in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileBetween(String value1, String value2) {
            addCriterion("Mobile between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotBetween(String value1, String value2) {
            addCriterion("Mobile not between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andBlanceIsNull() {
            addCriterion("Blance is null");
            return (Criteria) this;
        }

        public Criteria andBlanceIsNotNull() {
            addCriterion("Blance is not null");
            return (Criteria) this;
        }

        public Criteria andBlanceEqualTo(BigDecimal value) {
            addCriterion("Blance =", value, "blance");
            return (Criteria) this;
        }

        public Criteria andBlanceNotEqualTo(BigDecimal value) {
            addCriterion("Blance <>", value, "blance");
            return (Criteria) this;
        }

        public Criteria andBlanceGreaterThan(BigDecimal value) {
            addCriterion("Blance >", value, "blance");
            return (Criteria) this;
        }

        public Criteria andBlanceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Blance >=", value, "blance");
            return (Criteria) this;
        }

        public Criteria andBlanceLessThan(BigDecimal value) {
            addCriterion("Blance <", value, "blance");
            return (Criteria) this;
        }

        public Criteria andBlanceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Blance <=", value, "blance");
            return (Criteria) this;
        }

        public Criteria andBlanceIn(List<BigDecimal> values) {
            addCriterion("Blance in", values, "blance");
            return (Criteria) this;
        }

        public Criteria andBlanceNotIn(List<BigDecimal> values) {
            addCriterion("Blance not in", values, "blance");
            return (Criteria) this;
        }

        public Criteria andBlanceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Blance between", value1, value2, "blance");
            return (Criteria) this;
        }

        public Criteria andBlanceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Blance not between", value1, value2, "blance");
            return (Criteria) this;
        }

        public Criteria andFreerouteIsNull() {
            addCriterion("FreeRoute is null");
            return (Criteria) this;
        }

        public Criteria andFreerouteIsNotNull() {
            addCriterion("FreeRoute is not null");
            return (Criteria) this;
        }

        public Criteria andFreerouteEqualTo(String value) {
            addCriterion("FreeRoute =", value, "freeroute");
            return (Criteria) this;
        }

        public Criteria andFreerouteNotEqualTo(String value) {
            addCriterion("FreeRoute <>", value, "freeroute");
            return (Criteria) this;
        }

        public Criteria andFreerouteGreaterThan(String value) {
            addCriterion("FreeRoute >", value, "freeroute");
            return (Criteria) this;
        }

        public Criteria andFreerouteGreaterThanOrEqualTo(String value) {
            addCriterion("FreeRoute >=", value, "freeroute");
            return (Criteria) this;
        }

        public Criteria andFreerouteLessThan(String value) {
            addCriterion("FreeRoute <", value, "freeroute");
            return (Criteria) this;
        }

        public Criteria andFreerouteLessThanOrEqualTo(String value) {
            addCriterion("FreeRoute <=", value, "freeroute");
            return (Criteria) this;
        }

        public Criteria andFreerouteLike(String value) {
            addCriterion("FreeRoute like", value, "freeroute");
            return (Criteria) this;
        }

        public Criteria andFreerouteNotLike(String value) {
            addCriterion("FreeRoute not like", value, "freeroute");
            return (Criteria) this;
        }

        public Criteria andFreerouteIn(List<String> values) {
            addCriterion("FreeRoute in", values, "freeroute");
            return (Criteria) this;
        }

        public Criteria andFreerouteNotIn(List<String> values) {
            addCriterion("FreeRoute not in", values, "freeroute");
            return (Criteria) this;
        }

        public Criteria andFreerouteBetween(String value1, String value2) {
            addCriterion("FreeRoute between", value1, value2, "freeroute");
            return (Criteria) this;
        }

        public Criteria andFreerouteNotBetween(String value1, String value2) {
            addCriterion("FreeRoute not between", value1, value2, "freeroute");
            return (Criteria) this;
        }

        public Criteria andParentidIsNull() {
            addCriterion("ParentId is null");
            return (Criteria) this;
        }

        public Criteria andParentidIsNotNull() {
            addCriterion("ParentId is not null");
            return (Criteria) this;
        }

        public Criteria andParentidEqualTo(String value) {
            addCriterion("ParentId =", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidNotEqualTo(String value) {
            addCriterion("ParentId <>", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidGreaterThan(String value) {
            addCriterion("ParentId >", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidGreaterThanOrEqualTo(String value) {
            addCriterion("ParentId >=", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidLessThan(String value) {
            addCriterion("ParentId <", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidLessThanOrEqualTo(String value) {
            addCriterion("ParentId <=", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidLike(String value) {
            addCriterion("ParentId like", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidNotLike(String value) {
            addCriterion("ParentId not like", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidIn(List<String> values) {
            addCriterion("ParentId in", values, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidNotIn(List<String> values) {
            addCriterion("ParentId not in", values, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidBetween(String value1, String value2) {
            addCriterion("ParentId between", value1, value2, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidNotBetween(String value1, String value2) {
            addCriterion("ParentId not between", value1, value2, "parentid");
            return (Criteria) this;
        }

        public Criteria andAgentlogoIsNull() {
            addCriterion("AgentLogo is null");
            return (Criteria) this;
        }

        public Criteria andAgentlogoIsNotNull() {
            addCriterion("AgentLogo is not null");
            return (Criteria) this;
        }

        public Criteria andAgentlogoEqualTo(String value) {
            addCriterion("AgentLogo =", value, "agentlogo");
            return (Criteria) this;
        }

        public Criteria andAgentlogoNotEqualTo(String value) {
            addCriterion("AgentLogo <>", value, "agentlogo");
            return (Criteria) this;
        }

        public Criteria andAgentlogoGreaterThan(String value) {
            addCriterion("AgentLogo >", value, "agentlogo");
            return (Criteria) this;
        }

        public Criteria andAgentlogoGreaterThanOrEqualTo(String value) {
            addCriterion("AgentLogo >=", value, "agentlogo");
            return (Criteria) this;
        }

        public Criteria andAgentlogoLessThan(String value) {
            addCriterion("AgentLogo <", value, "agentlogo");
            return (Criteria) this;
        }

        public Criteria andAgentlogoLessThanOrEqualTo(String value) {
            addCriterion("AgentLogo <=", value, "agentlogo");
            return (Criteria) this;
        }

        public Criteria andAgentlogoLike(String value) {
            addCriterion("AgentLogo like", value, "agentlogo");
            return (Criteria) this;
        }

        public Criteria andAgentlogoNotLike(String value) {
            addCriterion("AgentLogo not like", value, "agentlogo");
            return (Criteria) this;
        }

        public Criteria andAgentlogoIn(List<String> values) {
            addCriterion("AgentLogo in", values, "agentlogo");
            return (Criteria) this;
        }

        public Criteria andAgentlogoNotIn(List<String> values) {
            addCriterion("AgentLogo not in", values, "agentlogo");
            return (Criteria) this;
        }

        public Criteria andAgentlogoBetween(String value1, String value2) {
            addCriterion("AgentLogo between", value1, value2, "agentlogo");
            return (Criteria) this;
        }

        public Criteria andAgentlogoNotBetween(String value1, String value2) {
            addCriterion("AgentLogo not between", value1, value2, "agentlogo");
            return (Criteria) this;
        }

        public Criteria andPrefixIsNull() {
            addCriterion("Prefix is null");
            return (Criteria) this;
        }

        public Criteria andPrefixIsNotNull() {
            addCriterion("Prefix is not null");
            return (Criteria) this;
        }

        public Criteria andPrefixEqualTo(String value) {
            addCriterion("Prefix =", value, "prefix");
            return (Criteria) this;
        }

        public Criteria andPrefixNotEqualTo(String value) {
            addCriterion("Prefix <>", value, "prefix");
            return (Criteria) this;
        }

        public Criteria andPrefixGreaterThan(String value) {
            addCriterion("Prefix >", value, "prefix");
            return (Criteria) this;
        }

        public Criteria andPrefixGreaterThanOrEqualTo(String value) {
            addCriterion("Prefix >=", value, "prefix");
            return (Criteria) this;
        }

        public Criteria andPrefixLessThan(String value) {
            addCriterion("Prefix <", value, "prefix");
            return (Criteria) this;
        }

        public Criteria andPrefixLessThanOrEqualTo(String value) {
            addCriterion("Prefix <=", value, "prefix");
            return (Criteria) this;
        }

        public Criteria andPrefixLike(String value) {
            addCriterion("Prefix like", value, "prefix");
            return (Criteria) this;
        }

        public Criteria andPrefixNotLike(String value) {
            addCriterion("Prefix not like", value, "prefix");
            return (Criteria) this;
        }

        public Criteria andPrefixIn(List<String> values) {
            addCriterion("Prefix in", values, "prefix");
            return (Criteria) this;
        }

        public Criteria andPrefixNotIn(List<String> values) {
            addCriterion("Prefix not in", values, "prefix");
            return (Criteria) this;
        }

        public Criteria andPrefixBetween(String value1, String value2) {
            addCriterion("Prefix between", value1, value2, "prefix");
            return (Criteria) this;
        }

        public Criteria andPrefixNotBetween(String value1, String value2) {
            addCriterion("Prefix not between", value1, value2, "prefix");
            return (Criteria) this;
        }

        public Criteria andThemeIsNull() {
            addCriterion("Theme is null");
            return (Criteria) this;
        }

        public Criteria andThemeIsNotNull() {
            addCriterion("Theme is not null");
            return (Criteria) this;
        }

        public Criteria andThemeEqualTo(String value) {
            addCriterion("Theme =", value, "theme");
            return (Criteria) this;
        }

        public Criteria andThemeNotEqualTo(String value) {
            addCriterion("Theme <>", value, "theme");
            return (Criteria) this;
        }

        public Criteria andThemeGreaterThan(String value) {
            addCriterion("Theme >", value, "theme");
            return (Criteria) this;
        }

        public Criteria andThemeGreaterThanOrEqualTo(String value) {
            addCriterion("Theme >=", value, "theme");
            return (Criteria) this;
        }

        public Criteria andThemeLessThan(String value) {
            addCriterion("Theme <", value, "theme");
            return (Criteria) this;
        }

        public Criteria andThemeLessThanOrEqualTo(String value) {
            addCriterion("Theme <=", value, "theme");
            return (Criteria) this;
        }

        public Criteria andThemeLike(String value) {
            addCriterion("Theme like", value, "theme");
            return (Criteria) this;
        }

        public Criteria andThemeNotLike(String value) {
            addCriterion("Theme not like", value, "theme");
            return (Criteria) this;
        }

        public Criteria andThemeIn(List<String> values) {
            addCriterion("Theme in", values, "theme");
            return (Criteria) this;
        }

        public Criteria andThemeNotIn(List<String> values) {
            addCriterion("Theme not in", values, "theme");
            return (Criteria) this;
        }

        public Criteria andThemeBetween(String value1, String value2) {
            addCriterion("Theme between", value1, value2, "theme");
            return (Criteria) this;
        }

        public Criteria andThemeNotBetween(String value1, String value2) {
            addCriterion("Theme not between", value1, value2, "theme");
            return (Criteria) this;
        }

        public Criteria andAddcardIsNull() {
            addCriterion("AddCard is null");
            return (Criteria) this;
        }

        public Criteria andAddcardIsNotNull() {
            addCriterion("AddCard is not null");
            return (Criteria) this;
        }

        public Criteria andAddcardEqualTo(Boolean value) {
            addCriterion("AddCard =", value, "addcard");
            return (Criteria) this;
        }

        public Criteria andAddcardNotEqualTo(Boolean value) {
            addCriterion("AddCard <>", value, "addcard");
            return (Criteria) this;
        }

        public Criteria andAddcardGreaterThan(Boolean value) {
            addCriterion("AddCard >", value, "addcard");
            return (Criteria) this;
        }

        public Criteria andAddcardGreaterThanOrEqualTo(Boolean value) {
            addCriterion("AddCard >=", value, "addcard");
            return (Criteria) this;
        }

        public Criteria andAddcardLessThan(Boolean value) {
            addCriterion("AddCard <", value, "addcard");
            return (Criteria) this;
        }

        public Criteria andAddcardLessThanOrEqualTo(Boolean value) {
            addCriterion("AddCard <=", value, "addcard");
            return (Criteria) this;
        }

        public Criteria andAddcardIn(List<Boolean> values) {
            addCriterion("AddCard in", values, "addcard");
            return (Criteria) this;
        }

        public Criteria andAddcardNotIn(List<Boolean> values) {
            addCriterion("AddCard not in", values, "addcard");
            return (Criteria) this;
        }

        public Criteria andAddcardBetween(Boolean value1, Boolean value2) {
            addCriterion("AddCard between", value1, value2, "addcard");
            return (Criteria) this;
        }

        public Criteria andAddcardNotBetween(Boolean value1, Boolean value2) {
            addCriterion("AddCard not between", value1, value2, "addcard");
            return (Criteria) this;
        }

        public Criteria andNextagentIsNull() {
            addCriterion("NextAgent is null");
            return (Criteria) this;
        }

        public Criteria andNextagentIsNotNull() {
            addCriterion("NextAgent is not null");
            return (Criteria) this;
        }

        public Criteria andNextagentEqualTo(Boolean value) {
            addCriterion("NextAgent =", value, "nextagent");
            return (Criteria) this;
        }

        public Criteria andNextagentNotEqualTo(Boolean value) {
            addCriterion("NextAgent <>", value, "nextagent");
            return (Criteria) this;
        }

        public Criteria andNextagentGreaterThan(Boolean value) {
            addCriterion("NextAgent >", value, "nextagent");
            return (Criteria) this;
        }

        public Criteria andNextagentGreaterThanOrEqualTo(Boolean value) {
            addCriterion("NextAgent >=", value, "nextagent");
            return (Criteria) this;
        }

        public Criteria andNextagentLessThan(Boolean value) {
            addCriterion("NextAgent <", value, "nextagent");
            return (Criteria) this;
        }

        public Criteria andNextagentLessThanOrEqualTo(Boolean value) {
            addCriterion("NextAgent <=", value, "nextagent");
            return (Criteria) this;
        }

        public Criteria andNextagentIn(List<Boolean> values) {
            addCriterion("NextAgent in", values, "nextagent");
            return (Criteria) this;
        }

        public Criteria andNextagentNotIn(List<Boolean> values) {
            addCriterion("NextAgent not in", values, "nextagent");
            return (Criteria) this;
        }

        public Criteria andNextagentBetween(Boolean value1, Boolean value2) {
            addCriterion("NextAgent between", value1, value2, "nextagent");
            return (Criteria) this;
        }

        public Criteria andNextagentNotBetween(Boolean value1, Boolean value2) {
            addCriterion("NextAgent not between", value1, value2, "nextagent");
            return (Criteria) this;
        }

        public Criteria andAndroidversionIsNull() {
            addCriterion("AndroidVersion is null");
            return (Criteria) this;
        }

        public Criteria andAndroidversionIsNotNull() {
            addCriterion("AndroidVersion is not null");
            return (Criteria) this;
        }

        public Criteria andAndroidversionEqualTo(String value) {
            addCriterion("AndroidVersion =", value, "androidversion");
            return (Criteria) this;
        }

        public Criteria andAndroidversionNotEqualTo(String value) {
            addCriterion("AndroidVersion <>", value, "androidversion");
            return (Criteria) this;
        }

        public Criteria andAndroidversionGreaterThan(String value) {
            addCriterion("AndroidVersion >", value, "androidversion");
            return (Criteria) this;
        }

        public Criteria andAndroidversionGreaterThanOrEqualTo(String value) {
            addCriterion("AndroidVersion >=", value, "androidversion");
            return (Criteria) this;
        }

        public Criteria andAndroidversionLessThan(String value) {
            addCriterion("AndroidVersion <", value, "androidversion");
            return (Criteria) this;
        }

        public Criteria andAndroidversionLessThanOrEqualTo(String value) {
            addCriterion("AndroidVersion <=", value, "androidversion");
            return (Criteria) this;
        }

        public Criteria andAndroidversionLike(String value) {
            addCriterion("AndroidVersion like", value, "androidversion");
            return (Criteria) this;
        }

        public Criteria andAndroidversionNotLike(String value) {
            addCriterion("AndroidVersion not like", value, "androidversion");
            return (Criteria) this;
        }

        public Criteria andAndroidversionIn(List<String> values) {
            addCriterion("AndroidVersion in", values, "androidversion");
            return (Criteria) this;
        }

        public Criteria andAndroidversionNotIn(List<String> values) {
            addCriterion("AndroidVersion not in", values, "androidversion");
            return (Criteria) this;
        }

        public Criteria andAndroidversionBetween(String value1, String value2) {
            addCriterion("AndroidVersion between", value1, value2, "androidversion");
            return (Criteria) this;
        }

        public Criteria andAndroidversionNotBetween(String value1, String value2) {
            addCriterion("AndroidVersion not between", value1, value2, "androidversion");
            return (Criteria) this;
        }

        public Criteria andAndroidpathIsNull() {
            addCriterion("AndroidPath is null");
            return (Criteria) this;
        }

        public Criteria andAndroidpathIsNotNull() {
            addCriterion("AndroidPath is not null");
            return (Criteria) this;
        }

        public Criteria andAndroidpathEqualTo(String value) {
            addCriterion("AndroidPath =", value, "androidpath");
            return (Criteria) this;
        }

        public Criteria andAndroidpathNotEqualTo(String value) {
            addCriterion("AndroidPath <>", value, "androidpath");
            return (Criteria) this;
        }

        public Criteria andAndroidpathGreaterThan(String value) {
            addCriterion("AndroidPath >", value, "androidpath");
            return (Criteria) this;
        }

        public Criteria andAndroidpathGreaterThanOrEqualTo(String value) {
            addCriterion("AndroidPath >=", value, "androidpath");
            return (Criteria) this;
        }

        public Criteria andAndroidpathLessThan(String value) {
            addCriterion("AndroidPath <", value, "androidpath");
            return (Criteria) this;
        }

        public Criteria andAndroidpathLessThanOrEqualTo(String value) {
            addCriterion("AndroidPath <=", value, "androidpath");
            return (Criteria) this;
        }

        public Criteria andAndroidpathLike(String value) {
            addCriterion("AndroidPath like", value, "androidpath");
            return (Criteria) this;
        }

        public Criteria andAndroidpathNotLike(String value) {
            addCriterion("AndroidPath not like", value, "androidpath");
            return (Criteria) this;
        }

        public Criteria andAndroidpathIn(List<String> values) {
            addCriterion("AndroidPath in", values, "androidpath");
            return (Criteria) this;
        }

        public Criteria andAndroidpathNotIn(List<String> values) {
            addCriterion("AndroidPath not in", values, "androidpath");
            return (Criteria) this;
        }

        public Criteria andAndroidpathBetween(String value1, String value2) {
            addCriterion("AndroidPath between", value1, value2, "androidpath");
            return (Criteria) this;
        }

        public Criteria andAndroidpathNotBetween(String value1, String value2) {
            addCriterion("AndroidPath not between", value1, value2, "androidpath");
            return (Criteria) this;
        }

        public Criteria andIosversionIsNull() {
            addCriterion("IOSVersion is null");
            return (Criteria) this;
        }

        public Criteria andIosversionIsNotNull() {
            addCriterion("IOSVersion is not null");
            return (Criteria) this;
        }

        public Criteria andIosversionEqualTo(String value) {
            addCriterion("IOSVersion =", value, "iosversion");
            return (Criteria) this;
        }

        public Criteria andIosversionNotEqualTo(String value) {
            addCriterion("IOSVersion <>", value, "iosversion");
            return (Criteria) this;
        }

        public Criteria andIosversionGreaterThan(String value) {
            addCriterion("IOSVersion >", value, "iosversion");
            return (Criteria) this;
        }

        public Criteria andIosversionGreaterThanOrEqualTo(String value) {
            addCriterion("IOSVersion >=", value, "iosversion");
            return (Criteria) this;
        }

        public Criteria andIosversionLessThan(String value) {
            addCriterion("IOSVersion <", value, "iosversion");
            return (Criteria) this;
        }

        public Criteria andIosversionLessThanOrEqualTo(String value) {
            addCriterion("IOSVersion <=", value, "iosversion");
            return (Criteria) this;
        }

        public Criteria andIosversionLike(String value) {
            addCriterion("IOSVersion like", value, "iosversion");
            return (Criteria) this;
        }

        public Criteria andIosversionNotLike(String value) {
            addCriterion("IOSVersion not like", value, "iosversion");
            return (Criteria) this;
        }

        public Criteria andIosversionIn(List<String> values) {
            addCriterion("IOSVersion in", values, "iosversion");
            return (Criteria) this;
        }

        public Criteria andIosversionNotIn(List<String> values) {
            addCriterion("IOSVersion not in", values, "iosversion");
            return (Criteria) this;
        }

        public Criteria andIosversionBetween(String value1, String value2) {
            addCriterion("IOSVersion between", value1, value2, "iosversion");
            return (Criteria) this;
        }

        public Criteria andIosversionNotBetween(String value1, String value2) {
            addCriterion("IOSVersion not between", value1, value2, "iosversion");
            return (Criteria) this;
        }

        public Criteria andIospathIsNull() {
            addCriterion("IOSPath is null");
            return (Criteria) this;
        }

        public Criteria andIospathIsNotNull() {
            addCriterion("IOSPath is not null");
            return (Criteria) this;
        }

        public Criteria andIospathEqualTo(String value) {
            addCriterion("IOSPath =", value, "iospath");
            return (Criteria) this;
        }

        public Criteria andIospathNotEqualTo(String value) {
            addCriterion("IOSPath <>", value, "iospath");
            return (Criteria) this;
        }

        public Criteria andIospathGreaterThan(String value) {
            addCriterion("IOSPath >", value, "iospath");
            return (Criteria) this;
        }

        public Criteria andIospathGreaterThanOrEqualTo(String value) {
            addCriterion("IOSPath >=", value, "iospath");
            return (Criteria) this;
        }

        public Criteria andIospathLessThan(String value) {
            addCriterion("IOSPath <", value, "iospath");
            return (Criteria) this;
        }

        public Criteria andIospathLessThanOrEqualTo(String value) {
            addCriterion("IOSPath <=", value, "iospath");
            return (Criteria) this;
        }

        public Criteria andIospathLike(String value) {
            addCriterion("IOSPath like", value, "iospath");
            return (Criteria) this;
        }

        public Criteria andIospathNotLike(String value) {
            addCriterion("IOSPath not like", value, "iospath");
            return (Criteria) this;
        }

        public Criteria andIospathIn(List<String> values) {
            addCriterion("IOSPath in", values, "iospath");
            return (Criteria) this;
        }

        public Criteria andIospathNotIn(List<String> values) {
            addCriterion("IOSPath not in", values, "iospath");
            return (Criteria) this;
        }

        public Criteria andIospathBetween(String value1, String value2) {
            addCriterion("IOSPath between", value1, value2, "iospath");
            return (Criteria) this;
        }

        public Criteria andIospathNotBetween(String value1, String value2) {
            addCriterion("IOSPath not between", value1, value2, "iospath");
            return (Criteria) this;
        }

        public Criteria andRegimoneyIsNull() {
            addCriterion("RegiMoney is null");
            return (Criteria) this;
        }

        public Criteria andRegimoneyIsNotNull() {
            addCriterion("RegiMoney is not null");
            return (Criteria) this;
        }

        public Criteria andRegimoneyEqualTo(Integer value) {
            addCriterion("RegiMoney =", value, "regimoney");
            return (Criteria) this;
        }

        public Criteria andRegimoneyNotEqualTo(Integer value) {
            addCriterion("RegiMoney <>", value, "regimoney");
            return (Criteria) this;
        }

        public Criteria andRegimoneyGreaterThan(Integer value) {
            addCriterion("RegiMoney >", value, "regimoney");
            return (Criteria) this;
        }

        public Criteria andRegimoneyGreaterThanOrEqualTo(Integer value) {
            addCriterion("RegiMoney >=", value, "regimoney");
            return (Criteria) this;
        }

        public Criteria andRegimoneyLessThan(Integer value) {
            addCriterion("RegiMoney <", value, "regimoney");
            return (Criteria) this;
        }

        public Criteria andRegimoneyLessThanOrEqualTo(Integer value) {
            addCriterion("RegiMoney <=", value, "regimoney");
            return (Criteria) this;
        }

        public Criteria andRegimoneyIn(List<Integer> values) {
            addCriterion("RegiMoney in", values, "regimoney");
            return (Criteria) this;
        }

        public Criteria andRegimoneyNotIn(List<Integer> values) {
            addCriterion("RegiMoney not in", values, "regimoney");
            return (Criteria) this;
        }

        public Criteria andRegimoneyBetween(Integer value1, Integer value2) {
            addCriterion("RegiMoney between", value1, value2, "regimoney");
            return (Criteria) this;
        }

        public Criteria andRegimoneyNotBetween(Integer value1, Integer value2) {
            addCriterion("RegiMoney not between", value1, value2, "regimoney");
            return (Criteria) this;
        }

        public Criteria andEndtimeIsNull() {
            addCriterion("EndTime is null");
            return (Criteria) this;
        }

        public Criteria andEndtimeIsNotNull() {
            addCriterion("EndTime is not null");
            return (Criteria) this;
        }

        public Criteria andEndtimeEqualTo(String value) {
            addCriterion("EndTime =", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeNotEqualTo(String value) {
            addCriterion("EndTime <>", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeGreaterThan(String value) {
            addCriterion("EndTime >", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeGreaterThanOrEqualTo(String value) {
            addCriterion("EndTime >=", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeLessThan(String value) {
            addCriterion("EndTime <", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeLessThanOrEqualTo(String value) {
            addCriterion("EndTime <=", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeLike(String value) {
            addCriterion("EndTime like", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeNotLike(String value) {
            addCriterion("EndTime not like", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeIn(List<String> values) {
            addCriterion("EndTime in", values, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeNotIn(List<String> values) {
            addCriterion("EndTime not in", values, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeBetween(String value1, String value2) {
            addCriterion("EndTime between", value1, value2, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeNotBetween(String value1, String value2) {
            addCriterion("EndTime not between", value1, value2, "endtime");
            return (Criteria) this;
        }

        public Criteria andPicIsNull() {
            addCriterion("Pic is null");
            return (Criteria) this;
        }

        public Criteria andPicIsNotNull() {
            addCriterion("Pic is not null");
            return (Criteria) this;
        }

        public Criteria andPicEqualTo(String value) {
            addCriterion("Pic =", value, "pic");
            return (Criteria) this;
        }

        public Criteria andPicNotEqualTo(String value) {
            addCriterion("Pic <>", value, "pic");
            return (Criteria) this;
        }

        public Criteria andPicGreaterThan(String value) {
            addCriterion("Pic >", value, "pic");
            return (Criteria) this;
        }

        public Criteria andPicGreaterThanOrEqualTo(String value) {
            addCriterion("Pic >=", value, "pic");
            return (Criteria) this;
        }

        public Criteria andPicLessThan(String value) {
            addCriterion("Pic <", value, "pic");
            return (Criteria) this;
        }

        public Criteria andPicLessThanOrEqualTo(String value) {
            addCriterion("Pic <=", value, "pic");
            return (Criteria) this;
        }

        public Criteria andPicLike(String value) {
            addCriterion("Pic like", value, "pic");
            return (Criteria) this;
        }

        public Criteria andPicNotLike(String value) {
            addCriterion("Pic not like", value, "pic");
            return (Criteria) this;
        }

        public Criteria andPicIn(List<String> values) {
            addCriterion("Pic in", values, "pic");
            return (Criteria) this;
        }

        public Criteria andPicNotIn(List<String> values) {
            addCriterion("Pic not in", values, "pic");
            return (Criteria) this;
        }

        public Criteria andPicBetween(String value1, String value2) {
            addCriterion("Pic between", value1, value2, "pic");
            return (Criteria) this;
        }

        public Criteria andPicNotBetween(String value1, String value2) {
            addCriterion("Pic not between", value1, value2, "pic");
            return (Criteria) this;
        }

        public Criteria andDkblIsNull() {
            addCriterion("DKBL is null");
            return (Criteria) this;
        }

        public Criteria andDkblIsNotNull() {
            addCriterion("DKBL is not null");
            return (Criteria) this;
        }

        public Criteria andDkblEqualTo(BigDecimal value) {
            addCriterion("DKBL =", value, "dkbl");
            return (Criteria) this;
        }

        public Criteria andDkblNotEqualTo(BigDecimal value) {
            addCriterion("DKBL <>", value, "dkbl");
            return (Criteria) this;
        }

        public Criteria andDkblGreaterThan(BigDecimal value) {
            addCriterion("DKBL >", value, "dkbl");
            return (Criteria) this;
        }

        public Criteria andDkblGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DKBL >=", value, "dkbl");
            return (Criteria) this;
        }

        public Criteria andDkblLessThan(BigDecimal value) {
            addCriterion("DKBL <", value, "dkbl");
            return (Criteria) this;
        }

        public Criteria andDkblLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DKBL <=", value, "dkbl");
            return (Criteria) this;
        }

        public Criteria andDkblIn(List<BigDecimal> values) {
            addCriterion("DKBL in", values, "dkbl");
            return (Criteria) this;
        }

        public Criteria andDkblNotIn(List<BigDecimal> values) {
            addCriterion("DKBL not in", values, "dkbl");
            return (Criteria) this;
        }

        public Criteria andDkblBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DKBL between", value1, value2, "dkbl");
            return (Criteria) this;
        }

        public Criteria andDkblNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DKBL not between", value1, value2, "dkbl");
            return (Criteria) this;
        }

        public Criteria andIsshopIsNull() {
            addCriterion("IsShop is null");
            return (Criteria) this;
        }

        public Criteria andIsshopIsNotNull() {
            addCriterion("IsShop is not null");
            return (Criteria) this;
        }

        public Criteria andIsshopEqualTo(Boolean value) {
            addCriterion("IsShop =", value, "isshop");
            return (Criteria) this;
        }

        public Criteria andIsshopNotEqualTo(Boolean value) {
            addCriterion("IsShop <>", value, "isshop");
            return (Criteria) this;
        }

        public Criteria andIsshopGreaterThan(Boolean value) {
            addCriterion("IsShop >", value, "isshop");
            return (Criteria) this;
        }

        public Criteria andIsshopGreaterThanOrEqualTo(Boolean value) {
            addCriterion("IsShop >=", value, "isshop");
            return (Criteria) this;
        }

        public Criteria andIsshopLessThan(Boolean value) {
            addCriterion("IsShop <", value, "isshop");
            return (Criteria) this;
        }

        public Criteria andIsshopLessThanOrEqualTo(Boolean value) {
            addCriterion("IsShop <=", value, "isshop");
            return (Criteria) this;
        }

        public Criteria andIsshopIn(List<Boolean> values) {
            addCriterion("IsShop in", values, "isshop");
            return (Criteria) this;
        }

        public Criteria andIsshopNotIn(List<Boolean> values) {
            addCriterion("IsShop not in", values, "isshop");
            return (Criteria) this;
        }

        public Criteria andIsshopBetween(Boolean value1, Boolean value2) {
            addCriterion("IsShop between", value1, value2, "isshop");
            return (Criteria) this;
        }

        public Criteria andIsshopNotBetween(Boolean value1, Boolean value2) {
            addCriterion("IsShop not between", value1, value2, "isshop");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("Type is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("Type is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("Type =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Integer value) {
            addCriterion("Type <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("Type >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("Type >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("Type <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Integer value) {
            addCriterion("Type <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Integer> values) {
            addCriterion("Type in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Integer> values) {
            addCriterion("Type not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Integer value1, Integer value2) {
            addCriterion("Type between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("Type not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andShopidIsNull() {
            addCriterion("ShopID is null");
            return (Criteria) this;
        }

        public Criteria andShopidIsNotNull() {
            addCriterion("ShopID is not null");
            return (Criteria) this;
        }

        public Criteria andShopidEqualTo(String value) {
            addCriterion("ShopID =", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidNotEqualTo(String value) {
            addCriterion("ShopID <>", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidGreaterThan(String value) {
            addCriterion("ShopID >", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidGreaterThanOrEqualTo(String value) {
            addCriterion("ShopID >=", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidLessThan(String value) {
            addCriterion("ShopID <", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidLessThanOrEqualTo(String value) {
            addCriterion("ShopID <=", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidLike(String value) {
            addCriterion("ShopID like", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidNotLike(String value) {
            addCriterion("ShopID not like", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidIn(List<String> values) {
            addCriterion("ShopID in", values, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidNotIn(List<String> values) {
            addCriterion("ShopID not in", values, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidBetween(String value1, String value2) {
            addCriterion("ShopID between", value1, value2, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidNotBetween(String value1, String value2) {
            addCriterion("ShopID not between", value1, value2, "shopid");
            return (Criteria) this;
        }

        public Criteria andAdidIsNull() {
            addCriterion("AdId is null");
            return (Criteria) this;
        }

        public Criteria andAdidIsNotNull() {
            addCriterion("AdId is not null");
            return (Criteria) this;
        }

        public Criteria andAdidEqualTo(String value) {
            addCriterion("AdId =", value, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidNotEqualTo(String value) {
            addCriterion("AdId <>", value, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidGreaterThan(String value) {
            addCriterion("AdId >", value, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidGreaterThanOrEqualTo(String value) {
            addCriterion("AdId >=", value, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidLessThan(String value) {
            addCriterion("AdId <", value, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidLessThanOrEqualTo(String value) {
            addCriterion("AdId <=", value, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidLike(String value) {
            addCriterion("AdId like", value, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidNotLike(String value) {
            addCriterion("AdId not like", value, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidIn(List<String> values) {
            addCriterion("AdId in", values, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidNotIn(List<String> values) {
            addCriterion("AdId not in", values, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidBetween(String value1, String value2) {
            addCriterion("AdId between", value1, value2, "adid");
            return (Criteria) this;
        }

        public Criteria andAdidNotBetween(String value1, String value2) {
            addCriterion("AdId not between", value1, value2, "adid");
            return (Criteria) this;
        }

        public Criteria andProfitratioIsNull() {
            addCriterion("ProfitRatio is null");
            return (Criteria) this;
        }

        public Criteria andProfitratioIsNotNull() {
            addCriterion("ProfitRatio is not null");
            return (Criteria) this;
        }

        public Criteria andProfitratioEqualTo(BigDecimal value) {
            addCriterion("ProfitRatio =", value, "profitratio");
            return (Criteria) this;
        }

        public Criteria andProfitratioNotEqualTo(BigDecimal value) {
            addCriterion("ProfitRatio <>", value, "profitratio");
            return (Criteria) this;
        }

        public Criteria andProfitratioGreaterThan(BigDecimal value) {
            addCriterion("ProfitRatio >", value, "profitratio");
            return (Criteria) this;
        }

        public Criteria andProfitratioGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ProfitRatio >=", value, "profitratio");
            return (Criteria) this;
        }

        public Criteria andProfitratioLessThan(BigDecimal value) {
            addCriterion("ProfitRatio <", value, "profitratio");
            return (Criteria) this;
        }

        public Criteria andProfitratioLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ProfitRatio <=", value, "profitratio");
            return (Criteria) this;
        }

        public Criteria andProfitratioIn(List<BigDecimal> values) {
            addCriterion("ProfitRatio in", values, "profitratio");
            return (Criteria) this;
        }

        public Criteria andProfitratioNotIn(List<BigDecimal> values) {
            addCriterion("ProfitRatio not in", values, "profitratio");
            return (Criteria) this;
        }

        public Criteria andProfitratioBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ProfitRatio between", value1, value2, "profitratio");
            return (Criteria) this;
        }

        public Criteria andProfitratioNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ProfitRatio not between", value1, value2, "profitratio");
            return (Criteria) this;
        }

        public Criteria andAppkeyIsNull() {
            addCriterion("AppKey is null");
            return (Criteria) this;
        }

        public Criteria andAppkeyIsNotNull() {
            addCriterion("AppKey is not null");
            return (Criteria) this;
        }

        public Criteria andAppkeyEqualTo(String value) {
            addCriterion("AppKey =", value, "appkey");
            return (Criteria) this;
        }

        public Criteria andAppkeyNotEqualTo(String value) {
            addCriterion("AppKey <>", value, "appkey");
            return (Criteria) this;
        }

        public Criteria andAppkeyGreaterThan(String value) {
            addCriterion("AppKey >", value, "appkey");
            return (Criteria) this;
        }

        public Criteria andAppkeyGreaterThanOrEqualTo(String value) {
            addCriterion("AppKey >=", value, "appkey");
            return (Criteria) this;
        }

        public Criteria andAppkeyLessThan(String value) {
            addCriterion("AppKey <", value, "appkey");
            return (Criteria) this;
        }

        public Criteria andAppkeyLessThanOrEqualTo(String value) {
            addCriterion("AppKey <=", value, "appkey");
            return (Criteria) this;
        }

        public Criteria andAppkeyLike(String value) {
            addCriterion("AppKey like", value, "appkey");
            return (Criteria) this;
        }

        public Criteria andAppkeyNotLike(String value) {
            addCriterion("AppKey not like", value, "appkey");
            return (Criteria) this;
        }

        public Criteria andAppkeyIn(List<String> values) {
            addCriterion("AppKey in", values, "appkey");
            return (Criteria) this;
        }

        public Criteria andAppkeyNotIn(List<String> values) {
            addCriterion("AppKey not in", values, "appkey");
            return (Criteria) this;
        }

        public Criteria andAppkeyBetween(String value1, String value2) {
            addCriterion("AppKey between", value1, value2, "appkey");
            return (Criteria) this;
        }

        public Criteria andAppkeyNotBetween(String value1, String value2) {
            addCriterion("AppKey not between", value1, value2, "appkey");
            return (Criteria) this;
        }

        public Criteria andAppsecretIsNull() {
            addCriterion("AppSecret is null");
            return (Criteria) this;
        }

        public Criteria andAppsecretIsNotNull() {
            addCriterion("AppSecret is not null");
            return (Criteria) this;
        }

        public Criteria andAppsecretEqualTo(String value) {
            addCriterion("AppSecret =", value, "appsecret");
            return (Criteria) this;
        }

        public Criteria andAppsecretNotEqualTo(String value) {
            addCriterion("AppSecret <>", value, "appsecret");
            return (Criteria) this;
        }

        public Criteria andAppsecretGreaterThan(String value) {
            addCriterion("AppSecret >", value, "appsecret");
            return (Criteria) this;
        }

        public Criteria andAppsecretGreaterThanOrEqualTo(String value) {
            addCriterion("AppSecret >=", value, "appsecret");
            return (Criteria) this;
        }

        public Criteria andAppsecretLessThan(String value) {
            addCriterion("AppSecret <", value, "appsecret");
            return (Criteria) this;
        }

        public Criteria andAppsecretLessThanOrEqualTo(String value) {
            addCriterion("AppSecret <=", value, "appsecret");
            return (Criteria) this;
        }

        public Criteria andAppsecretLike(String value) {
            addCriterion("AppSecret like", value, "appsecret");
            return (Criteria) this;
        }

        public Criteria andAppsecretNotLike(String value) {
            addCriterion("AppSecret not like", value, "appsecret");
            return (Criteria) this;
        }

        public Criteria andAppsecretIn(List<String> values) {
            addCriterion("AppSecret in", values, "appsecret");
            return (Criteria) this;
        }

        public Criteria andAppsecretNotIn(List<String> values) {
            addCriterion("AppSecret not in", values, "appsecret");
            return (Criteria) this;
        }

        public Criteria andAppsecretBetween(String value1, String value2) {
            addCriterion("AppSecret between", value1, value2, "appsecret");
            return (Criteria) this;
        }

        public Criteria andAppsecretNotBetween(String value1, String value2) {
            addCriterion("AppSecret not between", value1, value2, "appsecret");
            return (Criteria) this;
        }

        public Criteria andLinebalanceIsNull() {
            addCriterion("LineBalance is null");
            return (Criteria) this;
        }

        public Criteria andLinebalanceIsNotNull() {
            addCriterion("LineBalance is not null");
            return (Criteria) this;
        }

        public Criteria andLinebalanceEqualTo(BigDecimal value) {
            addCriterion("LineBalance =", value, "linebalance");
            return (Criteria) this;
        }

        public Criteria andLinebalanceNotEqualTo(BigDecimal value) {
            addCriterion("LineBalance <>", value, "linebalance");
            return (Criteria) this;
        }

        public Criteria andLinebalanceGreaterThan(BigDecimal value) {
            addCriterion("LineBalance >", value, "linebalance");
            return (Criteria) this;
        }

        public Criteria andLinebalanceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("LineBalance >=", value, "linebalance");
            return (Criteria) this;
        }

        public Criteria andLinebalanceLessThan(BigDecimal value) {
            addCriterion("LineBalance <", value, "linebalance");
            return (Criteria) this;
        }

        public Criteria andLinebalanceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("LineBalance <=", value, "linebalance");
            return (Criteria) this;
        }

        public Criteria andLinebalanceIn(List<BigDecimal> values) {
            addCriterion("LineBalance in", values, "linebalance");
            return (Criteria) this;
        }

        public Criteria andLinebalanceNotIn(List<BigDecimal> values) {
            addCriterion("LineBalance not in", values, "linebalance");
            return (Criteria) this;
        }

        public Criteria andLinebalanceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("LineBalance between", value1, value2, "linebalance");
            return (Criteria) this;
        }

        public Criteria andLinebalanceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("LineBalance not between", value1, value2, "linebalance");
            return (Criteria) this;
        }

        public Criteria andPidIsNull() {
            addCriterion("Pid is null");
            return (Criteria) this;
        }

        public Criteria andPidIsNotNull() {
            addCriterion("Pid is not null");
            return (Criteria) this;
        }

        public Criteria andPidEqualTo(String value) {
            addCriterion("Pid =", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotEqualTo(String value) {
            addCriterion("Pid <>", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidGreaterThan(String value) {
            addCriterion("Pid >", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidGreaterThanOrEqualTo(String value) {
            addCriterion("Pid >=", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidLessThan(String value) {
            addCriterion("Pid <", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidLessThanOrEqualTo(String value) {
            addCriterion("Pid <=", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidLike(String value) {
            addCriterion("Pid like", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotLike(String value) {
            addCriterion("Pid not like", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidIn(List<String> values) {
            addCriterion("Pid in", values, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotIn(List<String> values) {
            addCriterion("Pid not in", values, "pid");
            return (Criteria) this;
        }

        public Criteria andPidBetween(String value1, String value2) {
            addCriterion("Pid between", value1, value2, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotBetween(String value1, String value2) {
            addCriterion("Pid not between", value1, value2, "pid");
            return (Criteria) this;
        }

        public Criteria andDappkeyIsNull() {
            addCriterion("DAppKey is null");
            return (Criteria) this;
        }

        public Criteria andDappkeyIsNotNull() {
            addCriterion("DAppKey is not null");
            return (Criteria) this;
        }

        public Criteria andDappkeyEqualTo(String value) {
            addCriterion("DAppKey =", value, "dappkey");
            return (Criteria) this;
        }

        public Criteria andDappkeyNotEqualTo(String value) {
            addCriterion("DAppKey <>", value, "dappkey");
            return (Criteria) this;
        }

        public Criteria andDappkeyGreaterThan(String value) {
            addCriterion("DAppKey >", value, "dappkey");
            return (Criteria) this;
        }

        public Criteria andDappkeyGreaterThanOrEqualTo(String value) {
            addCriterion("DAppKey >=", value, "dappkey");
            return (Criteria) this;
        }

        public Criteria andDappkeyLessThan(String value) {
            addCriterion("DAppKey <", value, "dappkey");
            return (Criteria) this;
        }

        public Criteria andDappkeyLessThanOrEqualTo(String value) {
            addCriterion("DAppKey <=", value, "dappkey");
            return (Criteria) this;
        }

        public Criteria andDappkeyLike(String value) {
            addCriterion("DAppKey like", value, "dappkey");
            return (Criteria) this;
        }

        public Criteria andDappkeyNotLike(String value) {
            addCriterion("DAppKey not like", value, "dappkey");
            return (Criteria) this;
        }

        public Criteria andDappkeyIn(List<String> values) {
            addCriterion("DAppKey in", values, "dappkey");
            return (Criteria) this;
        }

        public Criteria andDappkeyNotIn(List<String> values) {
            addCriterion("DAppKey not in", values, "dappkey");
            return (Criteria) this;
        }

        public Criteria andDappkeyBetween(String value1, String value2) {
            addCriterion("DAppKey between", value1, value2, "dappkey");
            return (Criteria) this;
        }

        public Criteria andDappkeyNotBetween(String value1, String value2) {
            addCriterion("DAppKey not between", value1, value2, "dappkey");
            return (Criteria) this;
        }

        public Criteria andSqappkeyIsNull() {
            addCriterion("SqAppKey is null");
            return (Criteria) this;
        }

        public Criteria andSqappkeyIsNotNull() {
            addCriterion("SqAppKey is not null");
            return (Criteria) this;
        }

        public Criteria andSqappkeyEqualTo(String value) {
            addCriterion("SqAppKey =", value, "sqappkey");
            return (Criteria) this;
        }

        public Criteria andSqappkeyNotEqualTo(String value) {
            addCriterion("SqAppKey <>", value, "sqappkey");
            return (Criteria) this;
        }

        public Criteria andSqappkeyGreaterThan(String value) {
            addCriterion("SqAppKey >", value, "sqappkey");
            return (Criteria) this;
        }

        public Criteria andSqappkeyGreaterThanOrEqualTo(String value) {
            addCriterion("SqAppKey >=", value, "sqappkey");
            return (Criteria) this;
        }

        public Criteria andSqappkeyLessThan(String value) {
            addCriterion("SqAppKey <", value, "sqappkey");
            return (Criteria) this;
        }

        public Criteria andSqappkeyLessThanOrEqualTo(String value) {
            addCriterion("SqAppKey <=", value, "sqappkey");
            return (Criteria) this;
        }

        public Criteria andSqappkeyLike(String value) {
            addCriterion("SqAppKey like", value, "sqappkey");
            return (Criteria) this;
        }

        public Criteria andSqappkeyNotLike(String value) {
            addCriterion("SqAppKey not like", value, "sqappkey");
            return (Criteria) this;
        }

        public Criteria andSqappkeyIn(List<String> values) {
            addCriterion("SqAppKey in", values, "sqappkey");
            return (Criteria) this;
        }

        public Criteria andSqappkeyNotIn(List<String> values) {
            addCriterion("SqAppKey not in", values, "sqappkey");
            return (Criteria) this;
        }

        public Criteria andSqappkeyBetween(String value1, String value2) {
            addCriterion("SqAppKey between", value1, value2, "sqappkey");
            return (Criteria) this;
        }

        public Criteria andSqappkeyNotBetween(String value1, String value2) {
            addCriterion("SqAppKey not between", value1, value2, "sqappkey");
            return (Criteria) this;
        }

        public Criteria andOverdraftIsNull() {
            addCriterion("overdraft is null");
            return (Criteria) this;
        }

        public Criteria andOverdraftIsNotNull() {
            addCriterion("overdraft is not null");
            return (Criteria) this;
        }

        public Criteria andOverdraftEqualTo(Integer value) {
            addCriterion("overdraft =", value, "overdraft");
            return (Criteria) this;
        }

        public Criteria andOverdraftNotEqualTo(Integer value) {
            addCriterion("overdraft <>", value, "overdraft");
            return (Criteria) this;
        }

        public Criteria andOverdraftGreaterThan(Integer value) {
            addCriterion("overdraft >", value, "overdraft");
            return (Criteria) this;
        }

        public Criteria andOverdraftGreaterThanOrEqualTo(Integer value) {
            addCriterion("overdraft >=", value, "overdraft");
            return (Criteria) this;
        }

        public Criteria andOverdraftLessThan(Integer value) {
            addCriterion("overdraft <", value, "overdraft");
            return (Criteria) this;
        }

        public Criteria andOverdraftLessThanOrEqualTo(Integer value) {
            addCriterion("overdraft <=", value, "overdraft");
            return (Criteria) this;
        }

        public Criteria andOverdraftIn(List<Integer> values) {
            addCriterion("overdraft in", values, "overdraft");
            return (Criteria) this;
        }

        public Criteria andOverdraftNotIn(List<Integer> values) {
            addCriterion("overdraft not in", values, "overdraft");
            return (Criteria) this;
        }

        public Criteria andOverdraftBetween(Integer value1, Integer value2) {
            addCriterion("overdraft between", value1, value2, "overdraft");
            return (Criteria) this;
        }

        public Criteria andOverdraftNotBetween(Integer value1, Integer value2) {
            addCriterion("overdraft not between", value1, value2, "overdraft");
            return (Criteria) this;
        }

        public Criteria andAppstoreIsNull() {
            addCriterion("AppStore is null");
            return (Criteria) this;
        }

        public Criteria andAppstoreIsNotNull() {
            addCriterion("AppStore is not null");
            return (Criteria) this;
        }

        public Criteria andAppstoreEqualTo(String value) {
            addCriterion("AppStore =", value, "appstore");
            return (Criteria) this;
        }

        public Criteria andAppstoreNotEqualTo(String value) {
            addCriterion("AppStore <>", value, "appstore");
            return (Criteria) this;
        }

        public Criteria andAppstoreGreaterThan(String value) {
            addCriterion("AppStore >", value, "appstore");
            return (Criteria) this;
        }

        public Criteria andAppstoreGreaterThanOrEqualTo(String value) {
            addCriterion("AppStore >=", value, "appstore");
            return (Criteria) this;
        }

        public Criteria andAppstoreLessThan(String value) {
            addCriterion("AppStore <", value, "appstore");
            return (Criteria) this;
        }

        public Criteria andAppstoreLessThanOrEqualTo(String value) {
            addCriterion("AppStore <=", value, "appstore");
            return (Criteria) this;
        }

        public Criteria andAppstoreLike(String value) {
            addCriterion("AppStore like", value, "appstore");
            return (Criteria) this;
        }

        public Criteria andAppstoreNotLike(String value) {
            addCriterion("AppStore not like", value, "appstore");
            return (Criteria) this;
        }

        public Criteria andAppstoreIn(List<String> values) {
            addCriterion("AppStore in", values, "appstore");
            return (Criteria) this;
        }

        public Criteria andAppstoreNotIn(List<String> values) {
            addCriterion("AppStore not in", values, "appstore");
            return (Criteria) this;
        }

        public Criteria andAppstoreBetween(String value1, String value2) {
            addCriterion("AppStore between", value1, value2, "appstore");
            return (Criteria) this;
        }

        public Criteria andAppstoreNotBetween(String value1, String value2) {
            addCriterion("AppStore not between", value1, value2, "appstore");
            return (Criteria) this;
        }

        public Criteria andAppidIsNull() {
            addCriterion("Appid is null");
            return (Criteria) this;
        }

        public Criteria andAppidIsNotNull() {
            addCriterion("Appid is not null");
            return (Criteria) this;
        }

        public Criteria andAppidEqualTo(String value) {
            addCriterion("Appid =", value, "appid");
            return (Criteria) this;
        }

        public Criteria andAppidNotEqualTo(String value) {
            addCriterion("Appid <>", value, "appid");
            return (Criteria) this;
        }

        public Criteria andAppidGreaterThan(String value) {
            addCriterion("Appid >", value, "appid");
            return (Criteria) this;
        }

        public Criteria andAppidGreaterThanOrEqualTo(String value) {
            addCriterion("Appid >=", value, "appid");
            return (Criteria) this;
        }

        public Criteria andAppidLessThan(String value) {
            addCriterion("Appid <", value, "appid");
            return (Criteria) this;
        }

        public Criteria andAppidLessThanOrEqualTo(String value) {
            addCriterion("Appid <=", value, "appid");
            return (Criteria) this;
        }

        public Criteria andAppidLike(String value) {
            addCriterion("Appid like", value, "appid");
            return (Criteria) this;
        }

        public Criteria andAppidNotLike(String value) {
            addCriterion("Appid not like", value, "appid");
            return (Criteria) this;
        }

        public Criteria andAppidIn(List<String> values) {
            addCriterion("Appid in", values, "appid");
            return (Criteria) this;
        }

        public Criteria andAppidNotIn(List<String> values) {
            addCriterion("Appid not in", values, "appid");
            return (Criteria) this;
        }

        public Criteria andAppidBetween(String value1, String value2) {
            addCriterion("Appid between", value1, value2, "appid");
            return (Criteria) this;
        }

        public Criteria andAppidNotBetween(String value1, String value2) {
            addCriterion("Appid not between", value1, value2, "appid");
            return (Criteria) this;
        }

        public Criteria andKeypathIsNull() {
            addCriterion("KeyPath is null");
            return (Criteria) this;
        }

        public Criteria andKeypathIsNotNull() {
            addCriterion("KeyPath is not null");
            return (Criteria) this;
        }

        public Criteria andKeypathEqualTo(String value) {
            addCriterion("KeyPath =", value, "keypath");
            return (Criteria) this;
        }

        public Criteria andKeypathNotEqualTo(String value) {
            addCriterion("KeyPath <>", value, "keypath");
            return (Criteria) this;
        }

        public Criteria andKeypathGreaterThan(String value) {
            addCriterion("KeyPath >", value, "keypath");
            return (Criteria) this;
        }

        public Criteria andKeypathGreaterThanOrEqualTo(String value) {
            addCriterion("KeyPath >=", value, "keypath");
            return (Criteria) this;
        }

        public Criteria andKeypathLessThan(String value) {
            addCriterion("KeyPath <", value, "keypath");
            return (Criteria) this;
        }

        public Criteria andKeypathLessThanOrEqualTo(String value) {
            addCriterion("KeyPath <=", value, "keypath");
            return (Criteria) this;
        }

        public Criteria andKeypathLike(String value) {
            addCriterion("KeyPath like", value, "keypath");
            return (Criteria) this;
        }

        public Criteria andKeypathNotLike(String value) {
            addCriterion("KeyPath not like", value, "keypath");
            return (Criteria) this;
        }

        public Criteria andKeypathIn(List<String> values) {
            addCriterion("KeyPath in", values, "keypath");
            return (Criteria) this;
        }

        public Criteria andKeypathNotIn(List<String> values) {
            addCriterion("KeyPath not in", values, "keypath");
            return (Criteria) this;
        }

        public Criteria andKeypathBetween(String value1, String value2) {
            addCriterion("KeyPath between", value1, value2, "keypath");
            return (Criteria) this;
        }

        public Criteria andKeypathNotBetween(String value1, String value2) {
            addCriterion("KeyPath not between", value1, value2, "keypath");
            return (Criteria) this;
        }

        public Criteria andAgentprefixIsNull() {
            addCriterion("AgentPrefix is null");
            return (Criteria) this;
        }

        public Criteria andAgentprefixIsNotNull() {
            addCriterion("AgentPrefix is not null");
            return (Criteria) this;
        }

        public Criteria andAgentprefixEqualTo(String value) {
            addCriterion("AgentPrefix =", value, "agentprefix");
            return (Criteria) this;
        }

        public Criteria andAgentprefixNotEqualTo(String value) {
            addCriterion("AgentPrefix <>", value, "agentprefix");
            return (Criteria) this;
        }

        public Criteria andAgentprefixGreaterThan(String value) {
            addCriterion("AgentPrefix >", value, "agentprefix");
            return (Criteria) this;
        }

        public Criteria andAgentprefixGreaterThanOrEqualTo(String value) {
            addCriterion("AgentPrefix >=", value, "agentprefix");
            return (Criteria) this;
        }

        public Criteria andAgentprefixLessThan(String value) {
            addCriterion("AgentPrefix <", value, "agentprefix");
            return (Criteria) this;
        }

        public Criteria andAgentprefixLessThanOrEqualTo(String value) {
            addCriterion("AgentPrefix <=", value, "agentprefix");
            return (Criteria) this;
        }

        public Criteria andAgentprefixLike(String value) {
            addCriterion("AgentPrefix like", value, "agentprefix");
            return (Criteria) this;
        }

        public Criteria andAgentprefixNotLike(String value) {
            addCriterion("AgentPrefix not like", value, "agentprefix");
            return (Criteria) this;
        }

        public Criteria andAgentprefixIn(List<String> values) {
            addCriterion("AgentPrefix in", values, "agentprefix");
            return (Criteria) this;
        }

        public Criteria andAgentprefixNotIn(List<String> values) {
            addCriterion("AgentPrefix not in", values, "agentprefix");
            return (Criteria) this;
        }

        public Criteria andAgentprefixBetween(String value1, String value2) {
            addCriterion("AgentPrefix between", value1, value2, "agentprefix");
            return (Criteria) this;
        }

        public Criteria andAgentprefixNotBetween(String value1, String value2) {
            addCriterion("AgentPrefix not between", value1, value2, "agentprefix");
            return (Criteria) this;
        }

        public Criteria andOneagentIsNull() {
            addCriterion("OneAgent is null");
            return (Criteria) this;
        }

        public Criteria andOneagentIsNotNull() {
            addCriterion("OneAgent is not null");
            return (Criteria) this;
        }

        public Criteria andOneagentEqualTo(String value) {
            addCriterion("OneAgent =", value, "oneagent");
            return (Criteria) this;
        }

        public Criteria andOneagentNotEqualTo(String value) {
            addCriterion("OneAgent <>", value, "oneagent");
            return (Criteria) this;
        }

        public Criteria andOneagentGreaterThan(String value) {
            addCriterion("OneAgent >", value, "oneagent");
            return (Criteria) this;
        }

        public Criteria andOneagentGreaterThanOrEqualTo(String value) {
            addCriterion("OneAgent >=", value, "oneagent");
            return (Criteria) this;
        }

        public Criteria andOneagentLessThan(String value) {
            addCriterion("OneAgent <", value, "oneagent");
            return (Criteria) this;
        }

        public Criteria andOneagentLessThanOrEqualTo(String value) {
            addCriterion("OneAgent <=", value, "oneagent");
            return (Criteria) this;
        }

        public Criteria andOneagentLike(String value) {
            addCriterion("OneAgent like", value, "oneagent");
            return (Criteria) this;
        }

        public Criteria andOneagentNotLike(String value) {
            addCriterion("OneAgent not like", value, "oneagent");
            return (Criteria) this;
        }

        public Criteria andOneagentIn(List<String> values) {
            addCriterion("OneAgent in", values, "oneagent");
            return (Criteria) this;
        }

        public Criteria andOneagentNotIn(List<String> values) {
            addCriterion("OneAgent not in", values, "oneagent");
            return (Criteria) this;
        }

        public Criteria andOneagentBetween(String value1, String value2) {
            addCriterion("OneAgent between", value1, value2, "oneagent");
            return (Criteria) this;
        }

        public Criteria andOneagentNotBetween(String value1, String value2) {
            addCriterion("OneAgent not between", value1, value2, "oneagent");
            return (Criteria) this;
        }

        public Criteria andSxxhIsNull() {
            addCriterion("SXXH is null");
            return (Criteria) this;
        }

        public Criteria andSxxhIsNotNull() {
            addCriterion("SXXH is not null");
            return (Criteria) this;
        }

        public Criteria andSxxhEqualTo(Boolean value) {
            addCriterion("SXXH =", value, "sxxh");
            return (Criteria) this;
        }

        public Criteria andSxxhNotEqualTo(Boolean value) {
            addCriterion("SXXH <>", value, "sxxh");
            return (Criteria) this;
        }

        public Criteria andSxxhGreaterThan(Boolean value) {
            addCriterion("SXXH >", value, "sxxh");
            return (Criteria) this;
        }

        public Criteria andSxxhGreaterThanOrEqualTo(Boolean value) {
            addCriterion("SXXH >=", value, "sxxh");
            return (Criteria) this;
        }

        public Criteria andSxxhLessThan(Boolean value) {
            addCriterion("SXXH <", value, "sxxh");
            return (Criteria) this;
        }

        public Criteria andSxxhLessThanOrEqualTo(Boolean value) {
            addCriterion("SXXH <=", value, "sxxh");
            return (Criteria) this;
        }

        public Criteria andSxxhIn(List<Boolean> values) {
            addCriterion("SXXH in", values, "sxxh");
            return (Criteria) this;
        }

        public Criteria andSxxhNotIn(List<Boolean> values) {
            addCriterion("SXXH not in", values, "sxxh");
            return (Criteria) this;
        }

        public Criteria andSxxhBetween(Boolean value1, Boolean value2) {
            addCriterion("SXXH between", value1, value2, "sxxh");
            return (Criteria) this;
        }

        public Criteria andSxxhNotBetween(Boolean value1, Boolean value2) {
            addCriterion("SXXH not between", value1, value2, "sxxh");
            return (Criteria) this;
        }

        public Criteria andIsauthIsNull() {
            addCriterion("IsAuth is null");
            return (Criteria) this;
        }

        public Criteria andIsauthIsNotNull() {
            addCriterion("IsAuth is not null");
            return (Criteria) this;
        }

        public Criteria andIsauthEqualTo(Boolean value) {
            addCriterion("IsAuth =", value, "isauth");
            return (Criteria) this;
        }

        public Criteria andIsauthNotEqualTo(Boolean value) {
            addCriterion("IsAuth <>", value, "isauth");
            return (Criteria) this;
        }

        public Criteria andIsauthGreaterThan(Boolean value) {
            addCriterion("IsAuth >", value, "isauth");
            return (Criteria) this;
        }

        public Criteria andIsauthGreaterThanOrEqualTo(Boolean value) {
            addCriterion("IsAuth >=", value, "isauth");
            return (Criteria) this;
        }

        public Criteria andIsauthLessThan(Boolean value) {
            addCriterion("IsAuth <", value, "isauth");
            return (Criteria) this;
        }

        public Criteria andIsauthLessThanOrEqualTo(Boolean value) {
            addCriterion("IsAuth <=", value, "isauth");
            return (Criteria) this;
        }

        public Criteria andIsauthIn(List<Boolean> values) {
            addCriterion("IsAuth in", values, "isauth");
            return (Criteria) this;
        }

        public Criteria andIsauthNotIn(List<Boolean> values) {
            addCriterion("IsAuth not in", values, "isauth");
            return (Criteria) this;
        }

        public Criteria andIsauthBetween(Boolean value1, Boolean value2) {
            addCriterion("IsAuth between", value1, value2, "isauth");
            return (Criteria) this;
        }

        public Criteria andIsauthNotBetween(Boolean value1, Boolean value2) {
            addCriterion("IsAuth not between", value1, value2, "isauth");
            return (Criteria) this;
        }

        public Criteria andIsalipayIsNull() {
            addCriterion("IsAliPay is null");
            return (Criteria) this;
        }

        public Criteria andIsalipayIsNotNull() {
            addCriterion("IsAliPay is not null");
            return (Criteria) this;
        }

        public Criteria andIsalipayEqualTo(Boolean value) {
            addCriterion("IsAliPay =", value, "isalipay");
            return (Criteria) this;
        }

        public Criteria andIsalipayNotEqualTo(Boolean value) {
            addCriterion("IsAliPay <>", value, "isalipay");
            return (Criteria) this;
        }

        public Criteria andIsalipayGreaterThan(Boolean value) {
            addCriterion("IsAliPay >", value, "isalipay");
            return (Criteria) this;
        }

        public Criteria andIsalipayGreaterThanOrEqualTo(Boolean value) {
            addCriterion("IsAliPay >=", value, "isalipay");
            return (Criteria) this;
        }

        public Criteria andIsalipayLessThan(Boolean value) {
            addCriterion("IsAliPay <", value, "isalipay");
            return (Criteria) this;
        }

        public Criteria andIsalipayLessThanOrEqualTo(Boolean value) {
            addCriterion("IsAliPay <=", value, "isalipay");
            return (Criteria) this;
        }

        public Criteria andIsalipayIn(List<Boolean> values) {
            addCriterion("IsAliPay in", values, "isalipay");
            return (Criteria) this;
        }

        public Criteria andIsalipayNotIn(List<Boolean> values) {
            addCriterion("IsAliPay not in", values, "isalipay");
            return (Criteria) this;
        }

        public Criteria andIsalipayBetween(Boolean value1, Boolean value2) {
            addCriterion("IsAliPay between", value1, value2, "isalipay");
            return (Criteria) this;
        }

        public Criteria andIsalipayNotBetween(Boolean value1, Boolean value2) {
            addCriterion("IsAliPay not between", value1, value2, "isalipay");
            return (Criteria) this;
        }

        public Criteria andIsprofitIsNull() {
            addCriterion("IsProfit is null");
            return (Criteria) this;
        }

        public Criteria andIsprofitIsNotNull() {
            addCriterion("IsProfit is not null");
            return (Criteria) this;
        }

        public Criteria andIsprofitEqualTo(Boolean value) {
            addCriterion("IsProfit =", value, "isprofit");
            return (Criteria) this;
        }

        public Criteria andIsprofitNotEqualTo(Boolean value) {
            addCriterion("IsProfit <>", value, "isprofit");
            return (Criteria) this;
        }

        public Criteria andIsprofitGreaterThan(Boolean value) {
            addCriterion("IsProfit >", value, "isprofit");
            return (Criteria) this;
        }

        public Criteria andIsprofitGreaterThanOrEqualTo(Boolean value) {
            addCriterion("IsProfit >=", value, "isprofit");
            return (Criteria) this;
        }

        public Criteria andIsprofitLessThan(Boolean value) {
            addCriterion("IsProfit <", value, "isprofit");
            return (Criteria) this;
        }

        public Criteria andIsprofitLessThanOrEqualTo(Boolean value) {
            addCriterion("IsProfit <=", value, "isprofit");
            return (Criteria) this;
        }

        public Criteria andIsprofitIn(List<Boolean> values) {
            addCriterion("IsProfit in", values, "isprofit");
            return (Criteria) this;
        }

        public Criteria andIsprofitNotIn(List<Boolean> values) {
            addCriterion("IsProfit not in", values, "isprofit");
            return (Criteria) this;
        }

        public Criteria andIsprofitBetween(Boolean value1, Boolean value2) {
            addCriterion("IsProfit between", value1, value2, "isprofit");
            return (Criteria) this;
        }

        public Criteria andIsprofitNotBetween(Boolean value1, Boolean value2) {
            addCriterion("IsProfit not between", value1, value2, "isprofit");
            return (Criteria) this;
        }

        public Criteria andIsaliprofitIsNull() {
            addCriterion("IsAliProfit is null");
            return (Criteria) this;
        }

        public Criteria andIsaliprofitIsNotNull() {
            addCriterion("IsAliProfit is not null");
            return (Criteria) this;
        }

        public Criteria andIsaliprofitEqualTo(Boolean value) {
            addCriterion("IsAliProfit =", value, "isaliprofit");
            return (Criteria) this;
        }

        public Criteria andIsaliprofitNotEqualTo(Boolean value) {
            addCriterion("IsAliProfit <>", value, "isaliprofit");
            return (Criteria) this;
        }

        public Criteria andIsaliprofitGreaterThan(Boolean value) {
            addCriterion("IsAliProfit >", value, "isaliprofit");
            return (Criteria) this;
        }

        public Criteria andIsaliprofitGreaterThanOrEqualTo(Boolean value) {
            addCriterion("IsAliProfit >=", value, "isaliprofit");
            return (Criteria) this;
        }

        public Criteria andIsaliprofitLessThan(Boolean value) {
            addCriterion("IsAliProfit <", value, "isaliprofit");
            return (Criteria) this;
        }

        public Criteria andIsaliprofitLessThanOrEqualTo(Boolean value) {
            addCriterion("IsAliProfit <=", value, "isaliprofit");
            return (Criteria) this;
        }

        public Criteria andIsaliprofitIn(List<Boolean> values) {
            addCriterion("IsAliProfit in", values, "isaliprofit");
            return (Criteria) this;
        }

        public Criteria andIsaliprofitNotIn(List<Boolean> values) {
            addCriterion("IsAliProfit not in", values, "isaliprofit");
            return (Criteria) this;
        }

        public Criteria andIsaliprofitBetween(Boolean value1, Boolean value2) {
            addCriterion("IsAliProfit between", value1, value2, "isaliprofit");
            return (Criteria) this;
        }

        public Criteria andIsaliprofitNotBetween(Boolean value1, Boolean value2) {
            addCriterion("IsAliProfit not between", value1, value2, "isaliprofit");
            return (Criteria) this;
        }

        public Criteria andAliprofitratioIsNull() {
            addCriterion("AliProfitRatio is null");
            return (Criteria) this;
        }

        public Criteria andAliprofitratioIsNotNull() {
            addCriterion("AliProfitRatio is not null");
            return (Criteria) this;
        }

        public Criteria andAliprofitratioEqualTo(BigDecimal value) {
            addCriterion("AliProfitRatio =", value, "aliprofitratio");
            return (Criteria) this;
        }

        public Criteria andAliprofitratioNotEqualTo(BigDecimal value) {
            addCriterion("AliProfitRatio <>", value, "aliprofitratio");
            return (Criteria) this;
        }

        public Criteria andAliprofitratioGreaterThan(BigDecimal value) {
            addCriterion("AliProfitRatio >", value, "aliprofitratio");
            return (Criteria) this;
        }

        public Criteria andAliprofitratioGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("AliProfitRatio >=", value, "aliprofitratio");
            return (Criteria) this;
        }

        public Criteria andAliprofitratioLessThan(BigDecimal value) {
            addCriterion("AliProfitRatio <", value, "aliprofitratio");
            return (Criteria) this;
        }

        public Criteria andAliprofitratioLessThanOrEqualTo(BigDecimal value) {
            addCriterion("AliProfitRatio <=", value, "aliprofitratio");
            return (Criteria) this;
        }

        public Criteria andAliprofitratioIn(List<BigDecimal> values) {
            addCriterion("AliProfitRatio in", values, "aliprofitratio");
            return (Criteria) this;
        }

        public Criteria andAliprofitratioNotIn(List<BigDecimal> values) {
            addCriterion("AliProfitRatio not in", values, "aliprofitratio");
            return (Criteria) this;
        }

        public Criteria andAliprofitratioBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AliProfitRatio between", value1, value2, "aliprofitratio");
            return (Criteria) this;
        }

        public Criteria andAliprofitratioNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AliProfitRatio not between", value1, value2, "aliprofitratio");
            return (Criteria) this;
        }

        public Criteria andAliprofitmoneyIsNull() {
            addCriterion("AliProfitMoney is null");
            return (Criteria) this;
        }

        public Criteria andAliprofitmoneyIsNotNull() {
            addCriterion("AliProfitMoney is not null");
            return (Criteria) this;
        }

        public Criteria andAliprofitmoneyEqualTo(BigDecimal value) {
            addCriterion("AliProfitMoney =", value, "aliprofitmoney");
            return (Criteria) this;
        }

        public Criteria andAliprofitmoneyNotEqualTo(BigDecimal value) {
            addCriterion("AliProfitMoney <>", value, "aliprofitmoney");
            return (Criteria) this;
        }

        public Criteria andAliprofitmoneyGreaterThan(BigDecimal value) {
            addCriterion("AliProfitMoney >", value, "aliprofitmoney");
            return (Criteria) this;
        }

        public Criteria andAliprofitmoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("AliProfitMoney >=", value, "aliprofitmoney");
            return (Criteria) this;
        }

        public Criteria andAliprofitmoneyLessThan(BigDecimal value) {
            addCriterion("AliProfitMoney <", value, "aliprofitmoney");
            return (Criteria) this;
        }

        public Criteria andAliprofitmoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("AliProfitMoney <=", value, "aliprofitmoney");
            return (Criteria) this;
        }

        public Criteria andAliprofitmoneyIn(List<BigDecimal> values) {
            addCriterion("AliProfitMoney in", values, "aliprofitmoney");
            return (Criteria) this;
        }

        public Criteria andAliprofitmoneyNotIn(List<BigDecimal> values) {
            addCriterion("AliProfitMoney not in", values, "aliprofitmoney");
            return (Criteria) this;
        }

        public Criteria andAliprofitmoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AliProfitMoney between", value1, value2, "aliprofitmoney");
            return (Criteria) this;
        }

        public Criteria andAliprofitmoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AliProfitMoney not between", value1, value2, "aliprofitmoney");
            return (Criteria) this;
        }

        public Criteria andProfitmoneyIsNull() {
            addCriterion("ProfitMoney is null");
            return (Criteria) this;
        }

        public Criteria andProfitmoneyIsNotNull() {
            addCriterion("ProfitMoney is not null");
            return (Criteria) this;
        }

        public Criteria andProfitmoneyEqualTo(BigDecimal value) {
            addCriterion("ProfitMoney =", value, "profitmoney");
            return (Criteria) this;
        }

        public Criteria andProfitmoneyNotEqualTo(BigDecimal value) {
            addCriterion("ProfitMoney <>", value, "profitmoney");
            return (Criteria) this;
        }

        public Criteria andProfitmoneyGreaterThan(BigDecimal value) {
            addCriterion("ProfitMoney >", value, "profitmoney");
            return (Criteria) this;
        }

        public Criteria andProfitmoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ProfitMoney >=", value, "profitmoney");
            return (Criteria) this;
        }

        public Criteria andProfitmoneyLessThan(BigDecimal value) {
            addCriterion("ProfitMoney <", value, "profitmoney");
            return (Criteria) this;
        }

        public Criteria andProfitmoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ProfitMoney <=", value, "profitmoney");
            return (Criteria) this;
        }

        public Criteria andProfitmoneyIn(List<BigDecimal> values) {
            addCriterion("ProfitMoney in", values, "profitmoney");
            return (Criteria) this;
        }

        public Criteria andProfitmoneyNotIn(List<BigDecimal> values) {
            addCriterion("ProfitMoney not in", values, "profitmoney");
            return (Criteria) this;
        }

        public Criteria andProfitmoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ProfitMoney between", value1, value2, "profitmoney");
            return (Criteria) this;
        }

        public Criteria andProfitmoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ProfitMoney not between", value1, value2, "profitmoney");
            return (Criteria) this;
        }

        public Criteria andShopblanceIsNull() {
            addCriterion("ShopBlance is null");
            return (Criteria) this;
        }

        public Criteria andShopblanceIsNotNull() {
            addCriterion("ShopBlance is not null");
            return (Criteria) this;
        }

        public Criteria andShopblanceEqualTo(Integer value) {
            addCriterion("ShopBlance =", value, "shopblance");
            return (Criteria) this;
        }

        public Criteria andShopblanceNotEqualTo(Integer value) {
            addCriterion("ShopBlance <>", value, "shopblance");
            return (Criteria) this;
        }

        public Criteria andShopblanceGreaterThan(Integer value) {
            addCriterion("ShopBlance >", value, "shopblance");
            return (Criteria) this;
        }

        public Criteria andShopblanceGreaterThanOrEqualTo(Integer value) {
            addCriterion("ShopBlance >=", value, "shopblance");
            return (Criteria) this;
        }

        public Criteria andShopblanceLessThan(Integer value) {
            addCriterion("ShopBlance <", value, "shopblance");
            return (Criteria) this;
        }

        public Criteria andShopblanceLessThanOrEqualTo(Integer value) {
            addCriterion("ShopBlance <=", value, "shopblance");
            return (Criteria) this;
        }

        public Criteria andShopblanceIn(List<Integer> values) {
            addCriterion("ShopBlance in", values, "shopblance");
            return (Criteria) this;
        }

        public Criteria andShopblanceNotIn(List<Integer> values) {
            addCriterion("ShopBlance not in", values, "shopblance");
            return (Criteria) this;
        }

        public Criteria andShopblanceBetween(Integer value1, Integer value2) {
            addCriterion("ShopBlance between", value1, value2, "shopblance");
            return (Criteria) this;
        }

        public Criteria andShopblanceNotBetween(Integer value1, Integer value2) {
            addCriterion("ShopBlance not between", value1, value2, "shopblance");
            return (Criteria) this;
        }

        public Criteria andCalltypeIsNull() {
            addCriterion("CallType is null");
            return (Criteria) this;
        }

        public Criteria andCalltypeIsNotNull() {
            addCriterion("CallType is not null");
            return (Criteria) this;
        }

        public Criteria andCalltypeEqualTo(Integer value) {
            addCriterion("CallType =", value, "calltype");
            return (Criteria) this;
        }

        public Criteria andCalltypeNotEqualTo(Integer value) {
            addCriterion("CallType <>", value, "calltype");
            return (Criteria) this;
        }

        public Criteria andCalltypeGreaterThan(Integer value) {
            addCriterion("CallType >", value, "calltype");
            return (Criteria) this;
        }

        public Criteria andCalltypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("CallType >=", value, "calltype");
            return (Criteria) this;
        }

        public Criteria andCalltypeLessThan(Integer value) {
            addCriterion("CallType <", value, "calltype");
            return (Criteria) this;
        }

        public Criteria andCalltypeLessThanOrEqualTo(Integer value) {
            addCriterion("CallType <=", value, "calltype");
            return (Criteria) this;
        }

        public Criteria andCalltypeIn(List<Integer> values) {
            addCriterion("CallType in", values, "calltype");
            return (Criteria) this;
        }

        public Criteria andCalltypeNotIn(List<Integer> values) {
            addCriterion("CallType not in", values, "calltype");
            return (Criteria) this;
        }

        public Criteria andCalltypeBetween(Integer value1, Integer value2) {
            addCriterion("CallType between", value1, value2, "calltype");
            return (Criteria) this;
        }

        public Criteria andCalltypeNotBetween(Integer value1, Integer value2) {
            addCriterion("CallType not between", value1, value2, "calltype");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}